package com.example.speeddating.mapper;

import com.example.speeddating.entity.Profession;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 *
 * @author tina
 * @since 2023-06-28 11:14:33
 */
@Mapper
public interface ProfessionMapper extends BaseMapper<Profession> {

    @Select(value = "SELECT `name` FROM profession WHERE id = #{id}")
    String getProfessionNameById(Integer id);
}
